Re: OS X Install - Mailing list pgsql-general

From Jim Crate
Subject Re: OS X Install
Date
Msg-id r02010300-1035-C9DC1BEF2E7311D9A9910003939CD378@[63.175.177.209]
Whole thread Raw
In response to Re: OS X Install  (Joel <rees@ddcom.co.jp>)
Responses Re: OS X Install
List pgsql-general
I'm a little late to the party, but figured I could at least offer some info for
the archives.

If you don't know the user's password, and you have admin access, then it really
doesn't matter.  In fact, I set any special users (pgsql, mailman, etc.) up so
that they *cannot* be logged into normally.  Instead, do this:

sudo su - pgsql

and then all you need to know is your own password.

You can use niutil to create and delete users and groups.  Reading the man page
and exploring a bit using the -list and -read options will be very informative.

Here is a script I use to create a user. Execute it with sudo.



niutil -create . /groups/pgsql
niutil -createprop . /groups/pgsql gid 5001

niutil -create . /users/pgsql
niutil -createprop . /users/pgsql uid 5001
niutil -createprop . /users/pgsql gid 5001
niutil -createprop . /users/pgsql passwd \*
niutil -createprop . /users/pgsql home /Users/pgsql
niutil -createprop . /users/pgsql shell /bin/tcsh


gid and uid can be set to some non-conflicting number of your choice.  I believe
that numbers over 5000 do not show up in System Preferences or the login window.

--
Jim Crate
Deep Sky Technologies, Inc.

pgsql-general by date:

Previous
From: Leo Martin Orfei
Date:
Subject: create a text file from postgres (like Oracle UTL_FILE package)
Next
From: Tom Lane
Date:
Subject: Re: Selecting a random row